Overview

Dataset statistics

Number of variables17
Number of observations9994
Missing cells0
Missing cells (%)0.0%
Duplicate rows2448
Duplicate rows (%)24.5%
Total size in memory987.2 KiB
Average record size in memory101.1 B

Variable types

DateTime2
Categorical10
Numeric5

Alerts

Dataset has 2448 (24.5%) duplicate rowsDuplicates
Customer ID has a high cardinality: 793 distinct valuesHigh cardinality
City has a high cardinality: 531 distinct valuesHigh cardinality
Product ID has a high cardinality: 1862 distinct valuesHigh cardinality
Product Name has a high cardinality: 1850 distinct valuesHigh cardinality
Postal Code is highly overall correlated with State and 1 other fieldsHigh correlation
Sales is highly overall correlated with ProfitHigh correlation
Discount is highly overall correlated with ProfitHigh correlation
Profit is highly overall correlated with Sales and 1 other fieldsHigh correlation
State is highly overall correlated with Postal Code and 1 other fieldsHigh correlation
Region is highly overall correlated with Postal Code and 1 other fieldsHigh correlation
Category is highly overall correlated with Sub-CategoryHigh correlation
Sub-Category is highly overall correlated with CategoryHigh correlation
Discount has 4798 (48.0%) zerosZeros

Reproduction

Analysis started2023-04-03 16:33:47.906451
Analysis finished2023-04-03 16:34:14.977451
Duration27.07 seconds
Software versionydata-profiling vv4.1.2
Download configurationconfig.json

Variables

Distinct1237
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
Minimum2014-01-03 00:00:00
Maximum2017-12-30 00:00:00
2023-04-04T01:34:15.088505image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:15.232123image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct1334
Distinct (%)13.3%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
Minimum2014-01-07 00:00:00
Maximum2018-01-05 00:00:00
2023-04-04T01:34:15.377743image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:15.522002image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Ship Mode
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.1 KiB
Standard Class
5968 
Second Class
1945 
First Class
1538 
Same Day
 
543

Length

Max length14
Median length14
Mean length12.823094
Min length8

Characters and Unicode

Total characters128154
Distinct characters18
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSecond Class
2nd rowSecond Class
3rd rowSecond Class
4th rowStandard Class
5th rowStandard Class

Common Values

ValueCountFrequency (%)
Standard Class 5968
59.7%
Second Class 1945
 
19.5%
First Class 1538
 
15.4%
Same Day 543
 
5.4%

Length

2023-04-04T01:34:15.654509image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-04-04T01:34:15.757406image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
ValueCountFrequency (%)
class 9451
47.3%
standard 5968
29.9%
second 1945
 
9.7%
first 1538
 
7.7%
same 543
 
2.7%
day 543
 
2.7%

Most occurring characters

ValueCountFrequency (%)
a 22473
17.5%
s 20440
15.9%
d 13881
10.8%
9994
7.8%
l 9451
7.4%
C 9451
7.4%
S 8456
 
6.6%
n 7913
 
6.2%
r 7506
 
5.9%
t 7506
 
5.9%
Other values (8) 11083
8.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 98172
76.6%
Uppercase Letter 19988
 
15.6%
Space Separator 9994
 
7.8%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 22473
22.9%
s 20440
20.8%
d 13881
14.1%
l 9451
9.6%
n 7913
 
8.1%
r 7506
 
7.6%
t 7506
 
7.6%
e 2488
 
2.5%
c 1945
 
2.0%
o 1945
 
2.0%
Other values (3) 2624
 
2.7%
Uppercase Letter
ValueCountFrequency (%)
C 9451
47.3%
S 8456
42.3%
F 1538
 
7.7%
D 543
 
2.7%
Space Separator
ValueCountFrequency (%)
9994
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 118160
92.2%
Common 9994
 
7.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 22473
19.0%
s 20440
17.3%
d 13881
11.7%
l 9451
8.0%
C 9451
8.0%
S 8456
 
7.2%
n 7913
 
6.7%
r 7506
 
6.4%
t 7506
 
6.4%
e 2488
 
2.1%
Other values (7) 8595
 
7.3%
Common
ValueCountFrequency (%)
9994
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 128154
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 22473
17.5%
s 20440
15.9%
d 13881
10.8%
9994
7.8%
l 9451
7.4%
C 9451
7.4%
S 8456
 
6.6%
n 7913
 
6.2%
r 7506
 
5.9%
t 7506
 
5.9%
Other values (8) 11083
8.6%

Customer ID
Categorical

Distinct793
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
WB-21850
 
37
MA-17560
 
34
PP-18955
 
34
JL-15835
 
34
CK-12205
 
32
Other values (788)
9823 

Length

Max length8
Median length8
Mean length8
Min length8

Characters and Unicode

Total characters79952
Distinct characters40
Distinct categories4 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique5 ?
Unique (%)0.1%

Sample

1st rowCG-12520
2nd rowCG-12520
3rd rowDV-13045
4th rowSO-20335
5th rowSO-20335

Common Values

ValueCountFrequency (%)
WB-21850 37
 
0.4%
MA-17560 34
 
0.3%
PP-18955 34
 
0.3%
JL-15835 34
 
0.3%
CK-12205 32
 
0.3%
SV-20365 32
 
0.3%
JD-15895 32
 
0.3%
EH-13765 32
 
0.3%
ZC-21910 31
 
0.3%
EP-13915 31
 
0.3%
Other values (783) 9665
96.7%

Length

2023-04-04T01:34:15.849878image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
wb-21850 37
 
0.4%
pp-18955 34
 
0.3%
jl-15835 34
 
0.3%
ma-17560 34
 
0.3%
ck-12205 32
 
0.3%
sv-20365 32
 
0.3%
jd-15895 32
 
0.3%
eh-13765 32
 
0.3%
zc-21910 31
 
0.3%
ep-13915 31
 
0.3%
Other values (783) 9665
96.7%

Most occurring characters

ValueCountFrequency (%)
1 11915
14.9%
- 9994
12.5%
0 8532
 
10.7%
5 7865
 
9.8%
2 4682
 
5.9%
7 2931
 
3.7%
6 2909
 
3.6%
9 2904
 
3.6%
8 2818
 
3.5%
3 2779
 
3.5%
Other values (30) 22623
28.3%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 49970
62.5%
Uppercase Letter 19945
 
24.9%
Dash Punctuation 9994
 
12.5%
Lowercase Letter 43
 
0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
S 1798
 
9.0%
C 1725
 
8.6%
M 1712
 
8.6%
B 1642
 
8.2%
D 1296
 
6.5%
A 1227
 
6.2%
J 1134
 
5.7%
P 1105
 
5.5%
H 968
 
4.9%
K 932
 
4.7%
Other values (16) 6406
32.1%
Decimal Number
ValueCountFrequency (%)
1 11915
23.8%
0 8532
17.1%
5 7865
15.7%
2 4682
 
9.4%
7 2931
 
5.9%
6 2909
 
5.8%
9 2904
 
5.8%
8 2818
 
5.6%
3 2779
 
5.6%
4 2635
 
5.3%
Lowercase Letter
ValueCountFrequency (%)
p 29
67.4%
o 8
 
18.6%
l 6
 
14.0%
Dash Punctuation
ValueCountFrequency (%)
- 9994
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 59964
75.0%
Latin 19988
 
25.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
S 1798
 
9.0%
C 1725
 
8.6%
M 1712
 
8.6%
B 1642
 
8.2%
D 1296
 
6.5%
A 1227
 
6.1%
J 1134
 
5.7%
P 1105
 
5.5%
H 968
 
4.8%
K 932
 
4.7%
Other values (19) 6449
32.3%
Common
ValueCountFrequency (%)
1 11915
19.9%
- 9994
16.7%
0 8532
14.2%
5 7865
13.1%
2 4682
 
7.8%
7 2931
 
4.9%
6 2909
 
4.9%
9 2904
 
4.8%
8 2818
 
4.7%
3 2779
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 79952
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 11915
14.9%
- 9994
12.5%
0 8532
 
10.7%
5 7865
 
9.8%
2 4682
 
5.9%
7 2931
 
3.7%
6 2909
 
3.6%
9 2904
 
3.6%
8 2818
 
3.5%
3 2779
 
3.5%
Other values (30) 22623
28.3%

Segment
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Consumer
5191 
Corporate
3020 
Home Office
1783 

Length

Max length11
Median length8
Mean length8.8374024
Min length8

Characters and Unicode

Total characters88321
Distinct characters17
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowConsumer
2nd rowConsumer
3rd rowCorporate
4th rowConsumer
5th rowConsumer

Common Values

ValueCountFrequency (%)
Consumer 5191
51.9%
Corporate 3020
30.2%
Home Office 1783
 
17.8%

Length

2023-04-04T01:34:15.957914image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-04-04T01:34:16.061904image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
ValueCountFrequency (%)
consumer 5191
44.1%
corporate 3020
25.6%
home 1783
 
15.1%
office 1783
 
15.1%

Most occurring characters

ValueCountFrequency (%)
o 13014
14.7%
e 11777
13.3%
r 11231
12.7%
C 8211
9.3%
m 6974
7.9%
n 5191
 
5.9%
s 5191
 
5.9%
u 5191
 
5.9%
f 3566
 
4.0%
t 3020
 
3.4%
Other values (7) 14955
16.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 74761
84.6%
Uppercase Letter 11777
 
13.3%
Space Separator 1783
 
2.0%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 13014
17.4%
e 11777
15.8%
r 11231
15.0%
m 6974
9.3%
n 5191
 
6.9%
s 5191
 
6.9%
u 5191
 
6.9%
f 3566
 
4.8%
t 3020
 
4.0%
p 3020
 
4.0%
Other values (3) 6586
8.8%
Uppercase Letter
ValueCountFrequency (%)
C 8211
69.7%
H 1783
 
15.1%
O 1783
 
15.1%
Space Separator
ValueCountFrequency (%)
1783
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 86538
98.0%
Common 1783
 
2.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 13014
15.0%
e 11777
13.6%
r 11231
13.0%
C 8211
9.5%
m 6974
8.1%
n 5191
 
6.0%
s 5191
 
6.0%
u 5191
 
6.0%
f 3566
 
4.1%
t 3020
 
3.5%
Other values (6) 13172
15.2%
Common
ValueCountFrequency (%)
1783
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 88321
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
o 13014
14.7%
e 11777
13.3%
r 11231
12.7%
C 8211
9.3%
m 6974
7.9%
n 5191
 
5.9%
s 5191
 
5.9%
u 5191
 
5.9%
f 3566
 
4.0%
t 3020
 
3.4%
Other values (7) 14955
16.9%

City
Categorical

Distinct531
Distinct (%)5.3%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
New York City
915 
Los Angeles
747 
Philadelphia
 
537
San Francisco
 
510
Seattle
 
428
Other values (526)
6857 

Length

Max length17
Median length14
Mean length9.3306984
Min length4

Characters and Unicode

Total characters93251
Distinct characters51
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique70 ?
Unique (%)0.7%

Sample

1st rowHenderson
2nd rowHenderson
3rd rowLos Angeles
4th rowFort Lauderdale
5th rowFort Lauderdale

Common Values

ValueCountFrequency (%)
New York City 915
 
9.2%
Los Angeles 747
 
7.5%
Philadelphia 537
 
5.4%
San Francisco 510
 
5.1%
Seattle 428
 
4.3%
Houston 377
 
3.8%
Chicago 314
 
3.1%
Columbus 222
 
2.2%
San Diego 170
 
1.7%
Springfield 163
 
1.6%
Other values (521) 5611
56.1%

Length

2023-04-04T01:34:16.161809image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
city 994
 
7.0%
new 937
 
6.6%
york 920
 
6.5%
san 805
 
5.7%
los 747
 
5.2%
angeles 747
 
5.2%
philadelphia 537
 
3.8%
francisco 510
 
3.6%
seattle 428
 
3.0%
houston 377
 
2.6%
Other values (555) 7234
50.8%

Most occurring characters

ValueCountFrequency (%)
e 8719
 
9.4%
a 7591
 
8.1%
o 7499
 
8.0%
i 6229
 
6.7%
n 6199
 
6.6%
l 5986
 
6.4%
s 4699
 
5.0%
r 4468
 
4.8%
t 4438
 
4.8%
4242
 
4.5%
Other values (41) 33181
35.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 74773
80.2%
Uppercase Letter 14236
 
15.3%
Space Separator 4242
 
4.5%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 8719
11.7%
a 7591
10.2%
o 7499
10.0%
i 6229
 
8.3%
n 6199
 
8.3%
l 5986
 
8.0%
s 4699
 
6.3%
r 4468
 
6.0%
t 4438
 
5.9%
c 2393
 
3.2%
Other values (16) 16552
22.1%
Uppercase Letter
ValueCountFrequency (%)
C 2085
14.6%
S 1740
12.2%
L 1295
9.1%
A 1242
8.7%
N 1134
8.0%
P 1013
 
7.1%
Y 940
 
6.6%
F 794
 
5.6%
D 627
 
4.4%
H 617
 
4.3%
Other values (14) 2749
19.3%
Space Separator
ValueCountFrequency (%)
4242
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 89009
95.5%
Common 4242
 
4.5%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 8719
 
9.8%
a 7591
 
8.5%
o 7499
 
8.4%
i 6229
 
7.0%
n 6199
 
7.0%
l 5986
 
6.7%
s 4699
 
5.3%
r 4468
 
5.0%
t 4438
 
5.0%
c 2393
 
2.7%
Other values (40) 30788
34.6%
Common
ValueCountFrequency (%)
4242
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 93251
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 8719
 
9.4%
a 7591
 
8.1%
o 7499
 
8.0%
i 6229
 
6.7%
n 6199
 
6.6%
l 5986
 
6.4%
s 4699
 
5.0%
r 4468
 
4.8%
t 4438
 
4.8%
4242
 
4.5%
Other values (41) 33181
35.6%

State
Categorical

Distinct49
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
California
2001 
New York
1128 
Texas
985 
Pennsylvania
587 
Washington
506 
Other values (44)
4787 

Length

Max length20
Median length14
Mean length8.4871923
Min length4

Characters and Unicode

Total characters84821
Distinct characters46
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st rowKentucky
2nd rowKentucky
3rd rowCalifornia
4th rowFlorida
5th rowFlorida

Common Values

ValueCountFrequency (%)
California 2001
20.0%
New York 1128
 
11.3%
Texas 985
 
9.9%
Pennsylvania 587
 
5.9%
Washington 506
 
5.1%
Illinois 492
 
4.9%
Ohio 469
 
4.7%
Florida 383
 
3.8%
Michigan 255
 
2.6%
North Carolina 249
 
2.5%
Other values (39) 2939
29.4%

Length

2023-04-04T01:34:16.288826image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
california 2001
17.1%
new 1322
 
11.3%
york 1128
 
9.6%
texas 985
 
8.4%
pennsylvania 587
 
5.0%
washington 506
 
4.3%
illinois 492
 
4.2%
ohio 469
 
4.0%
florida 383
 
3.3%
carolina 291
 
2.5%
Other values (43) 3542
30.3%

Most occurring characters

ValueCountFrequency (%)
a 10758
12.7%
i 9895
11.7%
n 8090
 
9.5%
o 7323
 
8.6%
r 5544
 
6.5%
e 5051
 
6.0%
l 4822
 
5.7%
s 4604
 
5.4%
C 2566
 
3.0%
f 2011
 
2.4%
Other values (36) 24157
28.5%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 71413
84.2%
Uppercase Letter 11696
 
13.8%
Space Separator 1712
 
2.0%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 10758
15.1%
i 9895
13.9%
n 8090
11.3%
o 7323
10.3%
r 5544
7.8%
e 5051
7.1%
l 4822
6.8%
s 4604
6.4%
f 2011
 
2.8%
h 1898
 
2.7%
Other values (14) 11417
16.0%
Uppercase Letter
ValueCountFrequency (%)
C 2566
21.9%
N 1655
14.2%
T 1168
10.0%
Y 1128
9.6%
M 763
 
6.5%
I 748
 
6.4%
O 659
 
5.6%
W 621
 
5.3%
P 587
 
5.0%
F 383
 
3.3%
Other values (11) 1418
12.1%
Space Separator
ValueCountFrequency (%)
1712
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 83109
98.0%
Common 1712
 
2.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
a 10758
12.9%
i 9895
11.9%
n 8090
 
9.7%
o 7323
 
8.8%
r 5544
 
6.7%
e 5051
 
6.1%
l 4822
 
5.8%
s 4604
 
5.5%
C 2566
 
3.1%
f 2011
 
2.4%
Other values (35) 22445
27.0%
Common
ValueCountFrequency (%)
1712
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 84821
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
a 10758
12.7%
i 9895
11.7%
n 8090
 
9.5%
o 7323
 
8.6%
r 5544
 
6.5%
e 5051
 
6.0%
l 4822
 
5.7%
s 4604
 
5.4%
C 2566
 
3.0%
f 2011
 
2.4%
Other values (36) 24157
28.5%

Postal Code
Real number (ℝ)

Distinct631
Distinct (%)6.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean55190.379
Minimum1040
Maximum99301
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size78.2 KiB
2023-04-04T01:34:16.432057image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum1040
5-th percentile10009
Q123223
median56430.5
Q390008
95-th percentile98006
Maximum99301
Range98261
Interquartile range (IQR)66785

Descriptive statistics

Standard deviation32063.693
Coefficient of variation (CV)0.58096526
Kurtosis-1.4930202
Mean55190.379
Median Absolute Deviation (MAD)33573.5
Skewness-0.12852552
Sum5.5157265 × 108
Variance1.0280804 × 109
MonotonicityNot monotonic
2023-04-04T01:34:16.574330image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
10035 263
 
2.6%
10024 230
 
2.3%
10009 229
 
2.3%
94122 203
 
2.0%
10011 193
 
1.9%
94110 166
 
1.7%
98105 165
 
1.7%
19134 160
 
1.6%
98103 151
 
1.5%
90049 151
 
1.5%
Other values (621) 8083
80.9%
ValueCountFrequency (%)
1040 1
 
< 0.1%
1453 6
 
0.1%
1752 2
 
< 0.1%
1810 4
 
< 0.1%
1841 33
0.3%
1852 16
0.2%
1915 3
 
< 0.1%
2038 17
0.2%
2138 6
 
0.1%
2148 3
 
< 0.1%
ValueCountFrequency (%)
99301 6
 
0.1%
99207 7
 
0.1%
98661 5
 
0.1%
98632 3
 
< 0.1%
98502 5
 
0.1%
98270 2
 
< 0.1%
98226 3
 
< 0.1%
98208 1
 
< 0.1%
98198 7
 
0.1%
98115 112
1.1%

Region
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.1 KiB
West
3203 
East
2848 
Central
2323 
South
1620 

Length

Max length7
Median length4
Mean length4.8594156
Min length4

Characters and Unicode

Total characters48565
Distinct characters14
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowSouth
2nd rowSouth
3rd rowWest
4th rowSouth
5th rowSouth

Common Values

ValueCountFrequency (%)
West 3203
32.0%
East 2848
28.5%
Central 2323
23.2%
South 1620
16.2%

Length

2023-04-04T01:34:16.703999image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-04-04T01:34:16.807704image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
ValueCountFrequency (%)
west 3203
32.0%
east 2848
28.5%
central 2323
23.2%
south 1620
16.2%

Most occurring characters

ValueCountFrequency (%)
t 9994
20.6%
s 6051
12.5%
e 5526
11.4%
a 5171
10.6%
W 3203
 
6.6%
E 2848
 
5.9%
C 2323
 
4.8%
n 2323
 
4.8%
r 2323
 
4.8%
l 2323
 
4.8%
Other values (4) 6480
13.3%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 38571
79.4%
Uppercase Letter 9994
 
20.6%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
t 9994
25.9%
s 6051
15.7%
e 5526
14.3%
a 5171
13.4%
n 2323
 
6.0%
r 2323
 
6.0%
l 2323
 
6.0%
o 1620
 
4.2%
u 1620
 
4.2%
h 1620
 
4.2%
Uppercase Letter
ValueCountFrequency (%)
W 3203
32.0%
E 2848
28.5%
C 2323
23.2%
S 1620
16.2%

Most occurring scripts

ValueCountFrequency (%)
Latin 48565
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
t 9994
20.6%
s 6051
12.5%
e 5526
11.4%
a 5171
10.6%
W 3203
 
6.6%
E 2848
 
5.9%
C 2323
 
4.8%
n 2323
 
4.8%
r 2323
 
4.8%
l 2323
 
4.8%
Other values (4) 6480
13.3%

Most occurring blocks

ValueCountFrequency (%)
ASCII 48565
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
t 9994
20.6%
s 6051
12.5%
e 5526
11.4%
a 5171
10.6%
W 3203
 
6.6%
E 2848
 
5.9%
C 2323
 
4.8%
n 2323
 
4.8%
r 2323
 
4.8%
l 2323
 
4.8%
Other values (4) 6480
13.3%

Product ID
Categorical

Distinct1862
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
OFF-PA-10001970
 
19
TEC-AC-10003832
 
18
FUR-FU-10004270
 
16
FUR-CH-10001146
 
15
TEC-AC-10003628
 
15
Other values (1857)
9911 

Length

Max length15
Median length15
Mean length15
Min length15

Characters and Unicode

Total characters149910
Distinct characters27
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique91 ?
Unique (%)0.9%

Sample

1st rowFUR-BO-10001798
2nd rowFUR-CH-10000454
3rd rowOFF-LA-10000240
4th rowFUR-TA-10000577
5th rowOFF-ST-10000760

Common Values

ValueCountFrequency (%)
OFF-PA-10001970 19
 
0.2%
TEC-AC-10003832 18
 
0.2%
FUR-FU-10004270 16
 
0.2%
FUR-CH-10001146 15
 
0.2%
TEC-AC-10003628 15
 
0.2%
FUR-CH-10002647 15
 
0.2%
TEC-AC-10002049 15
 
0.2%
OFF-PA-10002377 14
 
0.1%
FUR-CH-10003774 14
 
0.1%
OFF-BI-10002026 14
 
0.1%
Other values (1852) 9839
98.4%

Length

2023-04-04T01:34:16.902784image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
off-pa-10001970 19
 
0.2%
tec-ac-10003832 18
 
0.2%
fur-fu-10004270 16
 
0.2%
fur-ch-10001146 15
 
0.2%
tec-ac-10003628 15
 
0.2%
fur-ch-10002647 15
 
0.2%
tec-ac-10002049 15
 
0.2%
fur-ch-10002880 14
 
0.1%
off-bi-10004632 14
 
0.1%
off-bi-10001524 14
 
0.1%
Other values (1852) 9839
98.4%

Most occurring characters

ValueCountFrequency (%)
0 35052
23.4%
- 19988
13.3%
F 15347
10.2%
1 14995
10.0%
O 6322
 
4.2%
2 4862
 
3.2%
4 4831
 
3.2%
3 4805
 
3.2%
A 4422
 
2.9%
5 3401
 
2.3%
Other values (17) 35885
23.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 79952
53.3%
Uppercase Letter 49970
33.3%
Dash Punctuation 19988
 
13.3%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
F 15347
30.7%
O 6322
12.7%
A 4422
 
8.8%
C 3307
 
6.6%
U 3268
 
6.5%
T 3012
 
6.0%
R 2917
 
5.8%
P 2725
 
5.5%
E 2101
 
4.2%
B 1751
 
3.5%
Other values (6) 4798
 
9.6%
Decimal Number
ValueCountFrequency (%)
0 35052
43.8%
1 14995
18.8%
2 4862
 
6.1%
4 4831
 
6.0%
3 4805
 
6.0%
5 3401
 
4.3%
7 3103
 
3.9%
9 3051
 
3.8%
6 2999
 
3.8%
8 2853
 
3.6%
Dash Punctuation
ValueCountFrequency (%)
- 19988
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 99940
66.7%
Latin 49970
33.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
F 15347
30.7%
O 6322
12.7%
A 4422
 
8.8%
C 3307
 
6.6%
U 3268
 
6.5%
T 3012
 
6.0%
R 2917
 
5.8%
P 2725
 
5.5%
E 2101
 
4.2%
B 1751
 
3.5%
Other values (6) 4798
 
9.6%
Common
ValueCountFrequency (%)
0 35052
35.1%
- 19988
20.0%
1 14995
15.0%
2 4862
 
4.9%
4 4831
 
4.8%
3 4805
 
4.8%
5 3401
 
3.4%
7 3103
 
3.1%
9 3051
 
3.1%
6 2999
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 149910
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 35052
23.4%
- 19988
13.3%
F 15347
10.2%
1 14995
10.0%
O 6322
 
4.2%
2 4862
 
3.2%
4 4831
 
3.2%
3 4805
 
3.2%
A 4422
 
2.9%
5 3401
 
2.3%
Other values (17) 35885
23.9%

Category
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size10.0 KiB
Office Supplies
6026 
Furniture
2121 
Technology
1847 

Length

Max length15
Median length15
Mean length12.802582
Min length9

Characters and Unicode

Total characters127949
Distinct characters20
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowFurniture
2nd rowFurniture
3rd rowOffice Supplies
4th rowFurniture
5th rowOffice Supplies

Common Values

ValueCountFrequency (%)
Office Supplies 6026
60.3%
Furniture 2121
 
21.2%
Technology 1847
 
18.5%

Length

2023-04-04T01:34:17.009328image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-04-04T01:34:17.115695image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
ValueCountFrequency (%)
office 6026
37.6%
supplies 6026
37.6%
furniture 2121
 
13.2%
technology 1847
 
11.5%

Most occurring characters

ValueCountFrequency (%)
e 16020
12.5%
i 14173
11.1%
p 12052
9.4%
f 12052
9.4%
u 10268
 
8.0%
c 7873
 
6.2%
l 7873
 
6.2%
O 6026
 
4.7%
s 6026
 
4.7%
S 6026
 
4.7%
Other values (10) 29560
23.1%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 105903
82.8%
Uppercase Letter 16020
 
12.5%
Space Separator 6026
 
4.7%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 16020
15.1%
i 14173
13.4%
p 12052
11.4%
f 12052
11.4%
u 10268
9.7%
c 7873
7.4%
l 7873
7.4%
s 6026
 
5.7%
r 4242
 
4.0%
n 3968
 
3.7%
Other values (5) 11356
10.7%
Uppercase Letter
ValueCountFrequency (%)
O 6026
37.6%
S 6026
37.6%
F 2121
 
13.2%
T 1847
 
11.5%
Space Separator
ValueCountFrequency (%)
6026
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 121923
95.3%
Common 6026
 
4.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 16020
13.1%
i 14173
11.6%
p 12052
9.9%
f 12052
9.9%
u 10268
8.4%
c 7873
 
6.5%
l 7873
 
6.5%
O 6026
 
4.9%
s 6026
 
4.9%
S 6026
 
4.9%
Other values (9) 23534
19.3%
Common
ValueCountFrequency (%)
6026
100.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 127949
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
e 16020
12.5%
i 14173
11.1%
p 12052
9.4%
f 12052
9.4%
u 10268
 
8.0%
c 7873
 
6.2%
l 7873
 
6.2%
O 6026
 
4.7%
s 6026
 
4.7%
S 6026
 
4.7%
Other values (10) 29560
23.1%

Sub-Category
Categorical

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size10.6 KiB
Binders
1523 
Paper
1370 
Furnishings
957 
Phones
889 
Storage
846 
Other values (12)
4409 

Length

Max length11
Median length9
Mean length7.191715
Min length3

Characters and Unicode

Total characters71874
Distinct characters28
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowBookcases
2nd rowChairs
3rd rowLabels
4th rowTables
5th rowStorage

Common Values

ValueCountFrequency (%)
Binders 1523
15.2%
Paper 1370
13.7%
Furnishings 957
9.6%
Phones 889
8.9%
Storage 846
8.5%
Art 796
8.0%
Accessories 775
7.8%
Chairs 617
6.2%
Appliances 466
 
4.7%
Labels 364
 
3.6%
Other values (7) 1391
13.9%

Length

2023-04-04T01:34:17.219437image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
binders 1523
15.2%
paper 1370
13.7%
furnishings 957
9.6%
phones 889
8.9%
storage 846
8.5%
art 796
8.0%
accessories 775
7.8%
chairs 617
6.2%
appliances 466
 
4.7%
labels 364
 
3.6%
Other values (7) 1391
13.9%

Most occurring characters

ValueCountFrequency (%)
s 9934
13.8%
e 8870
12.3%
r 7169
 
10.0%
i 5668
 
7.9%
n 5378
 
7.5%
a 4542
 
6.3%
o 3288
 
4.6%
p 3004
 
4.2%
h 2578
 
3.6%
c 2359
 
3.3%
Other values (18) 19084
26.6%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 61880
86.1%
Uppercase Letter 9994
 
13.9%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
s 9934
16.1%
e 8870
14.3%
r 7169
11.6%
i 5668
9.2%
n 5378
8.7%
a 4542
7.3%
o 3288
 
5.3%
p 3004
 
4.9%
h 2578
 
4.2%
c 2359
 
3.8%
Other values (8) 9090
14.7%
Uppercase Letter
ValueCountFrequency (%)
P 2259
22.6%
A 2037
20.4%
B 1751
17.5%
F 1174
11.7%
S 1036
10.4%
C 685
 
6.9%
L 364
 
3.6%
T 319
 
3.2%
E 254
 
2.5%
M 115
 
1.2%

Most occurring scripts

ValueCountFrequency (%)
Latin 71874
100.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
s 9934
13.8%
e 8870
12.3%
r 7169
 
10.0%
i 5668
 
7.9%
n 5378
 
7.5%
a 4542
 
6.3%
o 3288
 
4.6%
p 3004
 
4.2%
h 2578
 
3.6%
c 2359
 
3.3%
Other values (18) 19084
26.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 71874
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
s 9934
13.8%
e 8870
12.3%
r 7169
 
10.0%
i 5668
 
7.9%
n 5378
 
7.5%
a 4542
 
6.3%
o 3288
 
4.6%
p 3004
 
4.2%
h 2578
 
3.6%
c 2359
 
3.3%
Other values (18) 19084
26.6%

Product Name
Categorical

Distinct1850
Distinct (%)18.5%
Missing0
Missing (%)0.0%
Memory size78.2 KiB
Staple envelope
 
48
Staples
 
46
Easy-staple paper
 
46
Avery Non-Stick Binders
 
20
Staples in misc. colors
 
19
Other values (1845)
9815 

Length

Max length127
Median length78
Mean length36.91605
Min length5

Characters and Unicode

Total characters368939
Distinct characters80
Distinct categories10 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique91 ?
Unique (%)0.9%

Sample

1st rowBush Somerset Collection Bookcase
2nd rowHon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back
3rd rowSelf-Adhesive Address Labels for Typewriters by Universal
4th rowBretford CR4500 Series Slim Rectangular Table
5th rowEldon Fold 'N Roll Cart System

Common Values

ValueCountFrequency (%)
Staple envelope 48
 
0.5%
Staples 46
 
0.5%
Easy-staple paper 46
 
0.5%
Avery Non-Stick Binders 20
 
0.2%
Staples in misc. colors 19
 
0.2%
Staple remover 18
 
0.2%
KI Adjustable-Height Table 18
 
0.2%
Storex Dura Pro Binders 17
 
0.2%
Staple-based wall hangings 16
 
0.2%
Situations Contoured Folding Chairs, 4/Set 15
 
0.2%
Other values (1840) 9731
97.4%

Length

2023-04-04T01:34:17.383520image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
xerox 865
 
1.6%
x 701
 
1.3%
with 589
 
1.1%
avery 557
 
1.0%
for 539
 
1.0%
binders 524
 
0.9%
490
 
0.9%
chair 479
 
0.9%
black 426
 
0.8%
phone 349
 
0.6%
Other values (2832) 50088
90.1%

Most occurring characters

ValueCountFrequency (%)
45670
 
12.4%
e 33538
 
9.1%
r 20791
 
5.6%
o 19902
 
5.4%
a 19064
 
5.2%
i 18648
 
5.1%
l 16365
 
4.4%
n 15622
 
4.2%
s 14683
 
4.0%
t 14550
 
3.9%
Other values (70) 150106
40.7%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 238236
64.6%
Uppercase Letter 56270
 
15.3%
Space Separator 45670
 
12.4%
Decimal Number 17981
 
4.9%
Other Punctuation 7152
 
1.9%
Dash Punctuation 2940
 
0.8%
Other Symbol 535
 
0.1%
Open Punctuation 60
 
< 0.1%
Close Punctuation 60
 
< 0.1%
Math Symbol 35
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 33538
14.1%
r 20791
 
8.7%
o 19902
 
8.4%
a 19064
 
8.0%
i 18648
 
7.8%
l 16365
 
6.9%
n 15622
 
6.6%
s 14683
 
6.2%
t 14550
 
6.1%
c 8924
 
3.7%
Other values (16) 56149
23.6%
Uppercase Letter
ValueCountFrequency (%)
S 6281
 
11.2%
C 6007
 
10.7%
B 5530
 
9.8%
P 4918
 
8.7%
A 2948
 
5.2%
D 2941
 
5.2%
M 2870
 
5.1%
T 2616
 
4.6%
F 2510
 
4.5%
L 2284
 
4.1%
Other values (16) 17365
30.9%
Other Punctuation
ValueCountFrequency (%)
, 3120
43.6%
/ 1561
21.8%
" 1300
18.2%
. 463
 
6.5%
& 287
 
4.0%
' 257
 
3.6%
# 90
 
1.3%
% 45
 
0.6%
* 9
 
0.1%
! 9
 
0.1%
Other values (2) 11
 
0.2%
Decimal Number
ValueCountFrequency (%)
1 3783
21.0%
0 2921
16.2%
2 2270
12.6%
4 1725
9.6%
3 1530
8.5%
5 1443
 
8.0%
8 1254
 
7.0%
9 1234
 
6.9%
6 941
 
5.2%
7 880
 
4.9%
Space Separator
ValueCountFrequency (%)
45670
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2940
100.0%
Other Symbol
ValueCountFrequency (%)
� 535
100.0%
Open Punctuation
ValueCountFrequency (%)
( 60
100.0%
Close Punctuation
ValueCountFrequency (%)
) 60
100.0%
Math Symbol
ValueCountFrequency (%)
+ 35
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 294506
79.8%
Common 74433
 
20.2%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 33538
 
11.4%
r 20791
 
7.1%
o 19902
 
6.8%
a 19064
 
6.5%
i 18648
 
6.3%
l 16365
 
5.6%
n 15622
 
5.3%
s 14683
 
5.0%
t 14550
 
4.9%
c 8924
 
3.0%
Other values (42) 112419
38.2%
Common
ValueCountFrequency (%)
45670
61.4%
1 3783
 
5.1%
, 3120
 
4.2%
- 2940
 
3.9%
0 2921
 
3.9%
2 2270
 
3.0%
4 1725
 
2.3%
/ 1561
 
2.1%
3 1530
 
2.1%
5 1443
 
1.9%
Other values (18) 7470
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 368404
99.9%
Specials 535
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
45670
 
12.4%
e 33538
 
9.1%
r 20791
 
5.6%
o 19902
 
5.4%
a 19064
 
5.2%
i 18648
 
5.1%
l 16365
 
4.4%
n 15622
 
4.2%
s 14683
 
4.0%
t 14550
 
3.9%
Other values (69) 149571
40.6%
Specials
ValueCountFrequency (%)
� 535
100.0%

Sales
Real number (ℝ)

Distinct5825
Distinct (%)58.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean229.858
Minimum0.444
Maximum22638.48
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size78.2 KiB
2023-04-04T01:34:17.533299image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum0.444
5-th percentile4.98
Q117.28
median54.49
Q3209.94
95-th percentile956.98425
Maximum22638.48
Range22638.036
Interquartile range (IQR)192.66

Descriptive statistics

Standard deviation623.2451
Coefficient of variation (CV)2.7114353
Kurtosis305.31175
Mean229.858
Median Absolute Deviation (MAD)45.406
Skewness12.972752
Sum2297200.9
Variance388434.46
MonotonicityNot monotonic
2023-04-04T01:34:17.669061image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
12.96 56
 
0.6%
19.44 39
 
0.4%
15.552 39
 
0.4%
25.92 36
 
0.4%
10.368 36
 
0.4%
32.4 28
 
0.3%
17.94 21
 
0.2%
6.48 21
 
0.2%
20.736 19
 
0.2%
14.94 17
 
0.2%
Other values (5815) 9682
96.9%
ValueCountFrequency (%)
0.444 1
 
< 0.1%
0.556 1
 
< 0.1%
0.836 1
 
< 0.1%
0.852 1
 
< 0.1%
0.876 1
 
< 0.1%
0.898 1
 
< 0.1%
0.984 1
 
< 0.1%
0.99 1
 
< 0.1%
1.044 1
 
< 0.1%
1.08 3
< 0.1%
ValueCountFrequency (%)
22638.48 1
< 0.1%
17499.95 1
< 0.1%
13999.96 1
< 0.1%
11199.968 1
< 0.1%
10499.97 1
< 0.1%
9892.74 1
< 0.1%
9449.95 1
< 0.1%
9099.93 1
< 0.1%
8749.95 1
< 0.1%
8399.976 1
< 0.1%

Quantity
Real number (ℝ)

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3.7895737
Minimum1
Maximum14
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size78.2 KiB
2023-04-04T01:34:17.778448image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median3
Q35
95-th percentile8
Maximum14
Range13
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.2251097
Coefficient of variation (CV)0.58716622
Kurtosis1.9918894
Mean3.7895737
Median Absolute Deviation (MAD)1
Skewness1.2785448
Sum37873
Variance4.9511131
MonotonicityNot monotonic
2023-04-04T01:34:17.881646image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
3 2409
24.1%
2 2402
24.0%
5 1230
12.3%
4 1191
11.9%
1 899
 
9.0%
7 606
 
6.1%
6 572
 
5.7%
9 258
 
2.6%
8 257
 
2.6%
10 57
 
0.6%
Other values (4) 113
 
1.1%
ValueCountFrequency (%)
1 899
 
9.0%
2 2402
24.0%
3 2409
24.1%
4 1191
11.9%
5 1230
12.3%
6 572
 
5.7%
7 606
 
6.1%
8 257
 
2.6%
9 258
 
2.6%
10 57
 
0.6%
ValueCountFrequency (%)
14 29
 
0.3%
13 27
 
0.3%
12 23
 
0.2%
11 34
 
0.3%
10 57
 
0.6%
9 258
 
2.6%
8 257
 
2.6%
7 606
6.1%
6 572
5.7%
5 1230
12.3%

Discount
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean0.15620272
Minimum0
Maximum0.8
Zeros4798
Zeros (%)48.0%
Negative0
Negative (%)0.0%
Memory size78.2 KiB
2023-04-04T01:34:17.988568image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median0.2
Q30.2
95-th percentile0.7
Maximum0.8
Range0.8
Interquartile range (IQR)0.2

Descriptive statistics

Standard deviation0.20645197
Coefficient of variation (CV)1.3216925
Kurtosis2.4095461
Mean0.15620272
Median Absolute Deviation (MAD)0.2
Skewness1.6842947
Sum1561.09
Variance0.042622415
MonotonicityNot monotonic
2023-04-04T01:34:18.109292image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
0 4798
48.0%
0.2 3657
36.6%
0.7 418
 
4.2%
0.8 300
 
3.0%
0.3 227
 
2.3%
0.4 206
 
2.1%
0.6 138
 
1.4%
0.1 94
 
0.9%
0.5 66
 
0.7%
0.15 52
 
0.5%
Other values (2) 38
 
0.4%
ValueCountFrequency (%)
0 4798
48.0%
0.1 94
 
0.9%
0.15 52
 
0.5%
0.2 3657
36.6%
0.3 227
 
2.3%
0.32 27
 
0.3%
0.4 206
 
2.1%
0.45 11
 
0.1%
0.5 66
 
0.7%
0.6 138
 
1.4%
ValueCountFrequency (%)
0.8 300
 
3.0%
0.7 418
 
4.2%
0.6 138
 
1.4%
0.5 66
 
0.7%
0.45 11
 
0.1%
0.4 206
 
2.1%
0.32 27
 
0.3%
0.3 227
 
2.3%
0.2 3657
36.6%
0.15 52
 
0.5%

Profit
Real number (ℝ)

Distinct7287
Distinct (%)72.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28.656896
Minimum-6599.978
Maximum8399.976
Zeros65
Zeros (%)0.7%
Negative1871
Negative (%)18.7%
Memory size78.2 KiB
2023-04-04T01:34:18.250240image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Quantile statistics

Minimum-6599.978
5-th percentile-53.03092
Q11.72875
median8.6665
Q329.364
95-th percentile168.4704
Maximum8399.976
Range14999.954
Interquartile range (IQR)27.63525

Descriptive statistics

Standard deviation234.26011
Coefficient of variation (CV)8.1746504
Kurtosis397.18851
Mean28.656896
Median Absolute Deviation (MAD)10.77855
Skewness7.5614316
Sum286397.02
Variance54877.798
MonotonicityNot monotonic
2023-04-04T01:34:18.383592image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 65
 
0.7%
6.2208 43
 
0.4%
9.3312 38
 
0.4%
5.4432 32
 
0.3%
3.6288 32
 
0.3%
15.552 26
 
0.3%
12.4416 21
 
0.2%
7.2576 19
 
0.2%
3.1104 18
 
0.2%
9.072 11
 
0.1%
Other values (7277) 9689
96.9%
ValueCountFrequency (%)
-6599.978 1
< 0.1%
-3839.9904 1
< 0.1%
-3701.8928 1
< 0.1%
-3399.98 1
< 0.1%
-2929.4845 1
< 0.1%
-2639.9912 1
< 0.1%
-2287.782 1
< 0.1%
-1862.3124 1
< 0.1%
-1850.9464 1
< 0.1%
-1811.0784 1
< 0.1%
ValueCountFrequency (%)
8399.976 1
< 0.1%
6719.9808 1
< 0.1%
5039.9856 1
< 0.1%
4946.37 1
< 0.1%
4630.4755 1
< 0.1%
3919.9888 1
< 0.1%
3177.475 1
< 0.1%
2799.984 1
< 0.1%
2591.9568 1
< 0.1%
2504.2216 1
< 0.1%

Interactions

2023-04-04T01:34:11.199883image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:33:49.150925image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:01.124177image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:04.366218image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:07.941576image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:13.956793image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:33:54.280633image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:03.903706image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:07.102331image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:10.689213image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:14.070135image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:33:55.916071image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:04.006123image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:07.214897image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:10.807106image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:14.192317image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:33:57.554466image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:04.120111image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:07.336664image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:10.932972image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:14.330388image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:33:59.493550image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:04.242944image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:07.468054image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
2023-04-04T01:34:11.063953image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/

Correlations

2023-04-04T01:34:18.507961image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Postal CodeSalesQuantityDiscountProfitShip ModeSegmentStateRegionCategorySub-Category
Postal Code1.0000.0030.010-0.0010.0220.3140.3090.9700.9680.0490.000
Sales0.0031.0000.327-0.0570.5180.0000.0020.0000.0000.0720.142
Quantity0.0100.3271.000-0.0010.2340.0000.0120.0040.0000.0000.000
Discount-0.001-0.057-0.0011.000-0.5430.0270.0050.3540.2940.3770.353
Profit0.0220.5180.234-0.5431.0000.0050.0000.0170.0210.0560.130
Ship Mode0.3140.0000.0000.0270.0051.0000.0330.0960.0220.0000.007
Segment0.3090.0020.0120.0050.0000.0331.0000.0900.0000.0000.000
State0.9700.0000.0040.3540.0170.0960.0901.0000.9980.0190.000
Region0.9680.0000.0000.2940.0210.0220.0000.9981.0000.0000.000
Category0.0490.0720.0000.3770.0560.0000.0000.0190.0001.0000.999
Sub-Category0.0000.1420.0000.3530.1300.0070.0000.0000.0000.9991.000

Missing values

2023-04-04T01:34:14.540821image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
A simple visualization of nullity by column.
2023-04-04T01:34:14.832653image/svg+xmlMatplotlib v3.6.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

Order DateShip DateShip ModeCustomer IDSegmentCityStatePostal CodeRegionProduct IDCategorySub-CategoryProduct NameSalesQuantityDiscountProfit
02016-11-082016-11-11Second ClassCG-12520ConsumerHendersonKentucky42420SouthFUR-BO-10001798FurnitureBookcasesBush Somerset Collection Bookcase261.960020.0041.9136
12016-11-082016-11-11Second ClassCG-12520ConsumerHendersonKentucky42420SouthFUR-CH-10000454FurnitureChairsHon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back731.940030.00219.5820
22016-06-122016-06-16Second ClassDV-13045CorporateLos AngelesCalifornia90036WestOFF-LA-10000240Office SuppliesLabelsSelf-Adhesive Address Labels for Typewriters by Universal14.620020.006.8714
32015-10-112015-10-18Standard ClassSO-20335ConsumerFort LauderdaleFlorida33311SouthFUR-TA-10000577FurnitureTablesBretford CR4500 Series Slim Rectangular Table957.577550.45-383.0310
42015-10-112015-10-18Standard ClassSO-20335ConsumerFort LauderdaleFlorida33311SouthOFF-ST-10000760Office SuppliesStorageEldon Fold 'N Roll Cart System22.368020.202.5164
52014-06-092014-06-14Standard ClassBH-11710ConsumerLos AngelesCalifornia90032WestFUR-FU-10001487FurnitureFurnishingsEldon Expressions Wood and Plastic Desk Accessories, Cherry Wood48.860070.0014.1694
62014-06-092014-06-14Standard ClassBH-11710ConsumerLos AngelesCalifornia90032WestOFF-AR-10002833Office SuppliesArtNewell 3227.280040.001.9656
72014-06-092014-06-14Standard ClassBH-11710ConsumerLos AngelesCalifornia90032WestTEC-PH-10002275TechnologyPhonesMitel 5320 IP Phone VoIP phone907.152060.2090.7152
82014-06-092014-06-14Standard ClassBH-11710ConsumerLos AngelesCalifornia90032WestOFF-BI-10003910Office SuppliesBindersDXL Angle-View Binders with Locking Rings by Samsill18.504030.205.7825
92014-06-092014-06-14Standard ClassBH-11710ConsumerLos AngelesCalifornia90032WestOFF-AP-10002892Office SuppliesAppliancesBelkin F5C206VTEL 6 Outlet Surge114.900050.0034.4700
Order DateShip DateShip ModeCustomer IDSegmentCityStatePostal CodeRegionProduct IDCategorySub-CategoryProduct NameSalesQuantityDiscountProfit
99842015-05-172015-05-23Standard ClassDV-13465ConsumerLong BeachNew York11561EastOFF-LA-10003766Office SuppliesLabelsSelf-Adhesive Removable Labels31.500100.015.1200
99852015-05-172015-05-23Standard ClassDV-13465ConsumerLong BeachNew York11561EastOFF-SU-10000898Office SuppliesSuppliesAcme Hot Forged Carbon Steel Scissors with Nickel-Plated Handles, 3 7/8" Cut, 8"L55.60040.016.1240
99862016-09-292016-10-03Standard ClassML-17410ConsumerLos AngelesCalifornia90008WestTEC-AC-10003399TechnologyAccessoriesMemorex Mini Travel Drive 64 GB USB 2.0 Flash Drive36.24010.015.2208
99872017-11-172017-11-21Standard ClassRA-19885CorporateAthensGeorgia30605SouthTEC-AC-10001539TechnologyAccessoriesLogitech G430 Surround Sound Gaming Headset with Dolby 7.1 Technology79.99010.028.7964
99882017-11-172017-11-21Standard ClassRA-19885CorporateAthensGeorgia30605SouthTEC-PH-10004006TechnologyPhonesPanasonic KX - TS880B Telephone206.10050.055.6470
99892014-01-212014-01-23Second ClassTB-21400ConsumerMiamiFlorida33180SouthFUR-FU-10001889FurnitureFurnishingsUltra Door Pull Handle25.24830.24.1028
99902017-02-262017-03-03Standard ClassDB-13060ConsumerCosta MesaCalifornia92627WestFUR-FU-10000747FurnitureFurnishingsTenex B1-RE Series Chair Mats for Low Pile Carpets91.96020.015.6332
99912017-02-262017-03-03Standard ClassDB-13060ConsumerCosta MesaCalifornia92627WestTEC-PH-10003645TechnologyPhonesAastra 57i VoIP phone258.57620.219.3932
99922017-02-262017-03-03Standard ClassDB-13060ConsumerCosta MesaCalifornia92627WestOFF-PA-10004041Office SuppliesPaperIt's Hot Message Books with Stickers, 2 3/4" x 5"29.60040.013.3200
99932017-05-042017-05-09Second ClassCC-12220ConsumerWestminsterCalifornia92683WestOFF-AP-10002684Office SuppliesAppliancesAcco 7-Outlet Masterpiece Power Center, Wihtout Fax/Phone Line Protection243.16020.072.9480

Duplicate rows

Most frequently occurring

Order DateShip DateShip ModeCustomer IDSegmentCityStatePostal CodeRegionProduct IDCategorySub-CategoryProduct NameSalesQuantityDiscountProfit# duplicates
23002014-04-232014-04-27Standard ClassLB-16795Home OfficeColumbusOhio43229EastFUR-CH-10002965FurnitureChairsGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05882
02014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureAccessoriesGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
12014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureAppliancesGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
22014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureArtGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
32014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureBindersGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
42014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureBookcasesGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
52014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureChairsGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
62014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureCopiersGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
72014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureEnvelopesGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880
82014-04-232014-04-27First ClassLB-16795ConsumerColumbusOhio43229CentralFUR-CH-10002965FurnitureFastenersGlobal Leather Highback Executive Chair with Pneumatic Height Adjustment, Black281.37220.3-12.05880